Software Engineer II - EDW
Description
At Frontier, seeing what's beyond the horizon is in our fiber. And we’ve been doing just that for over 80 years – connecting communities with emerging communications technology across the country. At Frontier, we’re transforming our business to break new ground and taking the digital revolution across the nation. We’ve invested over $1.6B to roll out fiber-fast internet to 10m+ homes by 2025. We’re growing our team so you can join us in exploring and opening new frontiers. Here, you’ll have the opportunity to build a powerful foundation for America’s future and yours.
What we’re seeking:
Software Engineer II (EDW) designs, and implements data initiatives and ETL solutions, which include the use of relational, dimensional, and SaaS data lake houses for the Enterprise Data Warehouse (EDW) team. These solutions support enterprise information management, business intelligence, machine learning, data science, GenAI, and other business interests. In this in-person role, you will be required to report to our Dallas, TX, location to complete your work responsibilities.
What you’ll do:
As part of the Enterprise Data Warehouse team, your responsibilities will include:
- Part of requirements gathering meetings with application teams, Database Administrators, and/or business partners to understand business needs
- Building and maintaining data pipelines and ETL processes
- Managing and ensuring data quality
- Responsible for developing Informatica IICS packages used in the Extract, Transform, and Load (ETL) processes for EDW
- Developing and maintaining the Operational data stores (ODS), Enterprise Data Warehouse (EDW), and associated data intelligence environments including data lakes, data marts, and metadata repositories
- Designing and implementing performance data movement pipelines using multiple ETL tools with batch and real-time event data streams (Databricks, Informatica, Apache Kafka, Azure Event Hub, AWS Kinesis, SQL Packages, etc.)
- Problem-solving of Data warehouse and ODS application issues and production errors, including high-level critical production issues that require immediate attention
What we offer:
Nothing is more important to our success than the team that built it. That’s why we provide benefits to keep you and your family well. Some of which we’re most proud to offer include:
- Salary Range: $51,000 - $130,000
- 20 PTO (Paid Time Off) days + 10 paid holidays per year
- Day one medical, dental, vision, and prescription drug plan
- 401k match of 50% on 6% of eligible compensation
- Same-sex spouse and domestic partner benefits coverage
- 10 weeks of paid parental leave, 3 weeks of paid caregiver leave, and up to $10k in adoption program assistance
What background you should have:
- Bachelor’s degree in management information systems, computer science, business, or a related field
- 1+ yrs of related experience in large corporate system environments working with large and complex systems
- Must have minimum knowledge with Data bricks/Snowflake
- Must have strong experience with AWS/AZURE/GCP
- Proficiency in at least one programming language (Python, Java, Scala, etc.)
- Knowledge of SQL and relational databases
- Experience with NO SQL/Columnar database is a plus
- Excellent written and verbal communication is a must
Frontier salaries are estimated by third parties and may or may not reflect actual or total compensation. Please confirm with your recruiter.
In our line of work, where making connections is paramount, fostering a culture of inclusion is fundamental to our values. We firmly believe in leveraging the strength of diversity to drive digital connectivity forward. If your background brings a unique perspective and value different from what we've outlined, we encourage you to apply and join us in our mission to #BuildGigabitAmerica.
Frontier Communications is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.
Frontier Communications is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.