ENGLEWOOD, CO, 80113, USA
14 hours ago
Senior Data Warehouse Engineer
**Company Summary** EchoStar is reimagining the future of connectivity. Our business reach spans satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products. Today, our brands include Boost Mobile, DISH TV, Gen Mobile, Hughes and Sling TV. **Department Summary** Our Technology teams challenge the status quo and reimagine capabilities across industries. Whether through research and development, technology innovation or solution engineering, our people play vital roles in connecting consumers with the products and platforms of tomorrow. **Job Duties and Responsibilities** As a **Senior Warehouse Data Engineer** , you'll lead the design and optimization of EDW applications. With expertise in AWS, SQL, Python, and diverse databases, you'll define standards, troubleshoot issues, and design robust ETL processes. Collaborate with cross-functional teams to create real-time data ingestion applications and leverage cutting-edge tools like Databricks and AWS services. If you're passionate about turning data into actionable insights and have a proven track record in data engineering, join us in shaping the success of our initiatives. **Key Responsibilities:** + Design, develop, integrate, enhance, troubleshoot, and fine-tune EDW (Enterprise Data Warehouse) applications + Analyze system requirements and deliver solutions + Design and develop applications using various technologies, including Amazon Web Services (AWS), SQL, Python, BTEQ, Teradata Loader and Export utilities, Shell Scripting, SQL Server, Redshift, Snowflake, Oracle, PostgreSQL, and Mongo databases + Define standards and procedures and refine methods and techniques for Data Extraction, Transformation, and Loading (ETL) + Evaluate and determine the root cause and resolve production issues + Write advanced SQL queries, including query tuning + Design and build complete ETL processes for moving and transforming data for Staging, EDW, and Data Marts + Design and develop data ingestion applications to stream real-time data from Kafka applications to a data lake and Snowflake database + Use Amazon Web Services applications such as S3, EC2, Athena, CloudWatch, Lambda, Redshift, etc. + Utilize Databricks application for large-scale data processing and streaming workloads + Work closely with analysts, engineers, and programmers to provide day-to-day technical support + Build reusable frameworks for data ingestion, data encryption/decryption, data tokenization, etc. + Utilize ETL tools such as Informatica, Autosys, Control-M, Golden Gate, Shell scripting, SQL, and AWS Redshift in carrying out data engineering tasks **Skills, Experience and Requirements** **Education and Experience:** + Bachelor's degree in a computer-related field preferred + 4+ years of experience as a Warehouse Engineer or similar experience **Skills and Qualifications:** + Ability to perform advanced duties independently and as a team member + Proficient in installation, configuration, troubleshooting, performance tuning, capacity planning, monitoring, documentation, administration, and architecture and design of patterns in complex computational environments + Optimal understanding of computer applications and programming concepts + Strong knowledge of RDBMS (Relational Database Management System) concepts and Data warehouse concepts + Familiarity with the software development lifecycle + Ability to gather and analyze data to achieve desired business goals and needs + Systematic use of software development lifecycle and RDBMS concepts + Analytical reasoning skills for systematic problem analysis + Experience with software engineering concepts, emphasizing the design phase + Skill in designing complex software test strategies + Knowledge of Linux environments and ability to resolve complex IT issues in a fast-paced setting **Salary Ranges** Compensation: $96,250.00/Year - $137,500.00/Year **Benefits** We offer versatile health perks, including flexible spending accounts, HSA, a 401(k) Plan with company match, ESPP, career opportunities and a flexible time away plan; all benefits can be viewed here: DISH Benefits . The base pay range shown is a guideline. Individual total compensation will vary based on factors such as qualifications, skill level and competencies; compensation is based on the role's location and is subject to change based on work location. Candidates need to successfully complete a pre-employment screen, which may include a drug test and DMV check. The posting will be active for a minimum of 3 days. The active posting will continue to extend by 3 days until the position is filled. We pride ourselves on developing and promoting talent as an Equal Employment Opportunity Employer - Veteran/Disability. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. All qualified applicants with arrest or conviction records will be considered for employment in accordance with local, state, and federal law. We are a true merit-based organization and work hard so there are no artificial barriers to one's potential success. DISH is committed to a workforce where everyone's opportunities are limitless. Please note that you may redact or remove any information that identifies age, date of birth or dates of school attendance/graduation from your application documents before submission and throughout our interview process.
Confirm your E-mail: Send Email