Data Engineer III - Network

Position Title:

Data Engineer III, Network (P3)

Company Summary

Crown Castle is the nation’s largest provider of shared communications infrastructure: towers, small cells and fiber. Whenever you make a call, track a workout or stream music and videos, we’re the ones providing the communications infrastructure that makes it possible to transform the way we live and work. From 5G and the internet of things to drones, autonomous vehicles and AR/VR, we enable the technologies that help people stay safe, connected and ready for the future. Crown Castle is publicly traded on the S&P 500, and one of the largest Real Estate Investment Trusts in the US.

Role

The Network Automation and Platforms (NAP) team provides innovative solutions using open-source and commercial technologies on-premises and in the cloud, to deliver critical data, geo-spatial, and automation capabilities to our customers. You will work in a highly collaborative team consisting of software architects, developers, database admins, network planners, and network engineers. As a Data Engineer III, you will interpret Network Engineering data requirements, procure datasets, and build reporting & analytical capabilities that will enable data-driven decisions leading to increased revenue and greater efficiencies for the network business. You will also assist in setting the data engineering strategy and implementation roadmap necessary to achieve our vision of a next generation, end-to-end autonomous network.

Position Summary

The Data Engineer III is responsible for automating the ingestion, transformation, and integration of data between applications and managing, advancing, and delivering business intelligence solutions based on that data to meet the business objectives of the organization's Network Engineering teams with minimal supervision.

Essential Job Functions

1. Meet with subject matter experts in network engineering areas of the business, quickly learn concepts and language relevant to their departments, and develop an understanding of how their data supports their business processes.
2. Develop and maintain efficient enterprise-grade dashboards, reports and datasets adhering to industry best practices.
3. Review, interpret, troubleshoot, and optimize complex SQL queries. Develop maintainable code via proper structures, comments, and design using best practices.
4. Provide database development and data integration support, developing database application code and data integration layers using database programming languages, ETL tools, APIs, and scripting languages.
5. Provide feedback as needed to internal and external resources that provide source data.
6. Continuously demonstrate proficiency in the use of business intelligence technologies.
7. Perform source data analysis – data profiling, validation, conceptual and logical data modeling, etc. – to determine the suitability of the source data for meeting the reporting requirements.
8. Research and understand business objectives and provide guidance, options, and proof of concepts (if appropriate) to solve business needs.
9. Work with third-party software vendors to manage both support and feature requests to improve the end-user experience.
10. Participate in weekly standups and provide code reviews for team projects.
11. Well organized and capable of executing on multiple high-level projects at the same time.
12. Adheres to project methodology, change management, and departmental procedures.
13. Develop documentation including but not limited to flowcharts and entity-relationship diagrams, as well as requirements and solutions.
14. Exceptional ability to interact in a team environment with peers and members of other teams that might be located remotely.

Education/Certifications

1. BS Degree in Engineering, Computer Science, or related technical discipline.
2. Code-camp with a portfolio and additional years of experience may be considered in lieu of a degree (put your GitHub, etc. link in your resume).

Experience/Minimum Requirements

1. 5+ years of experience with SQL database technologies such as PostgresSQL, Oracle, SQL Server, and MySQL including developing database-specific SQL queries, data modeling, migrations, and integration strategies.
2. 3+ years of design experience with BI reporting technologies in the creation of data-rich dashboards, such as Grafana and/or Power BI.
3. Proficiency with operational database and data warehouse design, ETL development, scalable data pipeline design, API integration and automation.
4. Proficiency with scripting languages such as Python (preferred), Ruby, and Go.
5. Experience with software development best practices, including coding standards, code reviews, source control management, automated build processes, testing, and operations.
6. Experience with modern ETL pipelines and schedulers a plus (e.g., Airflow, etc.)

Reports to:

Principal Architect

We offer a total benefits package and professional growth development for teammates in any stage of their career. Along with caring for our teammates, we’re an active member in the communities where we live, work and do business. We have a responsibility to give back, which we do through our Connected by Good program.

For New York City, Colorado, California, and Washington state residents:

The hiring range offered for this position is $101,800 - $146,400 annually. In addition to salary, employees are eligible for an annual bonus of up to 15% of annual salary and restricted stock. Employees (and their families) are eligible for medical, dental, vision, and basic life insurance. Employees are able to enroll in our company’s 401k plan. Employees will also receive 18 days of paid time off each year and 12 paid holidays throughout the calendar year.