Data Engineer Iii - Network

Position Title: Data Engineer III, Network (P3)

Company Summary:

Crown Castle works around the country to build and maintain the infrastructure behind the world’s most revolutionary technologies. As the largest shared infrastructure provider in the United States, Crown Castle owns, operates and leases more than 40,000 cell towers, 80,000 small cells and over 80,000 route miles of fiber across every major US market. This nationwide portfolio of communications infrastructure connects cities and communities to essential data, technology, and wireless service – bringing information, ideas and innovations to the people and businesses that need them. Crown Castle is a NYSE S&P 500 and Fortune 500 company and one of the largest Real Estate Investment Trusts in the United States with an enterprise value of approximately $110 billion.

Role:

The Network Services and Security team provides innovative solutions using open-source technologies on-premise 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.  You will interpret Network Engineering requirements, procure datasets, and build Reporting & Analytical capabilities that will enable data-driven decisions leading to increased revenue and greater efficiencies for the fiber business.

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:

• Meet with subject matter experts in network engineering areas of the business, be able to quickly learn concepts and language relevant to their departments and develop an understanding of how their data supports their business processes.
• Develop and maintain efficient enterprise-grade dashboards, reports and datasets adhering to industry best practices.
• Review, interpret, troubleshoot, and optimize complex SQL queries. Develop maintainable code via proper structures, comments, design using best practices.
• 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.
• Provide feedback as needed to internal and external resources that provide source data.
• Continuously demonstrate proficiency in the use of business intelligence technologies.
• 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.
• Research and understand business objectives and provide guidance, options, and proof of concepts (if appropriate) to solve business needs.
• Collaborate with partners to develop business requirements leading to successful project outcomes.
• Work with third-party software vendors to manage both support requests and feature requests to improve the end-user experience.
• Inform and drive innovative approaches for assigned solutions.
• Participate in weekly standups and provide code reviews for team projects.
• Well organized and capable of executing on multiple high-level projects at the same time.
• Adheres to project methodology, change management, and departmental procedures.
• Develop documentation including but not limited to flowcharts and entity-relationship diagrams, as well as requirements and solutions.
• Exceptional ability to interact in a team environment with peers and members of other teams that might be located remotely.

Education/Certifications:

• BS Degree in Engineering, Computer Science, or related technical discipline
• 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:

• 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.
• 3+ years of design experience with BI reporting technologies in the creation of data-rich dashboards, such as Grafana and/or Power BI.
• Proficiency with operational database and data warehouse design, ETL development, scalable data pipeline design, API integration and automation.
• Proficiency with fourth generation language scripting, such as Python, Ruby, and Go.
• Experience with software development best practices, including coding standards, code reviews, source control management, automated build processes, testing, and operations.

Reports to: Principal Architect

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.

#LI-Remote

#LI-MP1