Principal Data Warehouse Engineer

Your impact

Join the Data & Analytics team where you will focus on building complex solutions to process terabytes of data sourced from 50+ systems.

You will be part of the team focused on empowering data-driven decision-making throughout the organization. If you are a highly motivated and experienced Senior Data Engineer who is passionate about data, we want to hear from you.

In this role, you will join a dynamic team to design and develop scalable data pipelines and solutions within Snowflake and Oracle environments, leveraging Snow SQL, PL / SQL, DBT, and Python.

You will lead development efforts, engaging with internal users and contractors, and collaborating closely with cross-functional teams such as business analysts, data scientists, and Business Intelligence developers.

What you will do

• Design and develop innovative solutions using your experience with Data Warehouse architecture and Business Intelligence tools.
• Develop and maintain data ingestions / ETL processes to extract data from various sources using Snow SQL, Python, DBT, SQL, PL / SQL.
• Lead contractors and provide technical guidance to junior developers.
• Resolve technical issues, monitor progress against schedules; and produce appropriate support documentation for new or changed solutions.
• Collaborate with Business Analysist and users to understand business rules, capture requirements, and develop user stories.
• Transform and cleanse data to ensure high quality and consistency of the metrics.
• Build Subject Matter Expertise (SME) on specific business applications, including a deep understanding of the data.
• Participate in Sprint planning, daily standups, peer reviews, and retrospective meetings.
• Engage in requirements analysis, architectural and detail design reviews. Expand your knowledge of development languages, IDEs, and methodologies to enhance the extensive collection of SQL code and reports used at Intelsat.

Your required experience / skills

• Bachelor of Science degree in Information Systems or Computer Science
• At least 10 years of experience working as the developer in IT field.
• At least 6 years of professional experience working with Data Warehouse or Data Marts
• Proficient with :
• Relational data model
• Data Warehouse architecture
• Data Transformation
• Data Modeling
• ETL processes
• SQL queries
• PL / SQL development
• Python development
• Ability to work independently; reverse engineer code and make modifications.
• Experience with designing and managing Star schema, slowly changing conformed dimensions.
• Ability to express ideas clearly both in written and oral communications.
• Strong ability to learn new technologies and document ways to implement.
• Understanding of the full lifecycle development process, including understanding business and functional requirements
• Strong organizational skills with a willingness to work with others to foster a team spirit
• Proven track record on delivery.

Your success in this role will look like :

• Collaborating effectively with the Business Intelligence, Analytics and other Solution Engineering team members
• Effectively communicating technical concepts to both technical and non-technical stakeholders.
• Work independently with the stakeholders to learn complex business rules and mathematical computation.
• Ability to analyze complex situations, identify root causes of issues, and develop effective solutions.
• Demonstrating a dedication to staying updated with the latest trends and technologies in the data engineering field.

It would be nice if you had :

• Database design and Data Governance experience
• Knowledge of Snowflake, live data streaming, Power BI, Grafana
• Geojson data mapping on Power BI or Tableau
• Understanding of and experience with :
• Kafka, API
• Data testing
• Understanding of Oracle ERP, ServiceNow and Salesfore data models and principles
• Experience working in Telecommunication Industry
• Understanding of Network Management System (Gilat)
• A broad knowledge of telecommunication systems

How we support you :

• Hybrid work environment offering up to two days per week work from home (for eligible positions)
• Development opportunities supporting professional growth championed by our dedicated Learning & Development team. 20-25% of our positions are hired internally!
• Ways to get involved : satellite launch parties, company connect events, charitable activities, team social events, recognition programs, and employee resource groups.
• Wide range of benefits and perks to help you stay healthy, happy, and productive. These include paid leave programs, medical, tuition reimbursement, and retirement benefits, employee wellness offerings, and more!

These benefits are designed to support your overall well-being and help you succeed in your role.

Our D&I Commitment

We're committed to fostering a culture and environment of diversity, inclusion and respect a place where everyone can show up fully as themselves and do their best work every day.

We're a technology leader committed to advancing diverse, inclusive teams where belonging is rooted in our culture. Intelsat has an established Diversity & Inclusion Council and Employee Resource Groups.

Intelsat is an equal opportunity employer and does not discriminate based upon race, color, religion, sex, national origin, ethnicity, age, disability, pregnancy, veteran status, sexual orientation, gender identity or any other characteristic protected by applicable law.

While it is important to note that meeting the minimum qualifications is a fundamental requirement for consideration, if you are enthusiastic about this role and are unsure how well your experience aligns with these requirements, we encourage you to apply.

Our recruitment team will assess your application and determine if your skills and qualifications meet the essential criteria for this role or whether there might be another role within our organization that is a better match.

Other Job Info :

These statements are intended to describe the general nature and level of work being performed by employees assigned to this job.

This is not intended to be an exhaustive list of all responsibilities, duties, and skills required of employees assigned to this job.

• Job requires ability to sit for long periods of time
• Job requires to work from the McLean office in Northern Virginia USA
• This role is subject to ITAR / EAR; candidates must be a US Person (this includes US Citizen, Permanent Resident or Protected Individual such as an asylee or refugee
30+ days ago