Senior Data Analytics Engineer

Michael & Susan Dell Foundation

The Michael & Susan Dell Foundation (www.dell.org) is dedicated to improving the lives of children living in urban poverty around the world. With offices in Austin, TX, New Delhi, India, and Cape Town, South Africa, the Dell Foundation funds programs that foster high-quality public education and childhood health and improve the economic stability of families living in poverty. To date, the foundation has committed more than $2 billion to global children’s issues and community initiatives to accelerate opportunity for low-income families.

Our mission demands that we seek out and embrace many different voices because bringing together a diversity of ideas and experiences is the most powerful way we know to ensure the people we serve have opportunities to succeed. To achieve this vision, we must create a diverse team and inclusive culture, listen to the people we serve, and build authentic and trusting partnerships. We work to overcome both the causes and the consequences of major inequities and systemic racism by ensuring that resources and opportunities are fairly distributed.

Current Opportunity: Senior Data Analytics Engineer, Austin, TX

The Michael and Susan Dell Foundation is looking for a Senior Data Analytics engineer to join our Enterprise & Data Services team. This person will be responsible for the design, development, deployment, and maintenance of business intelligence data solutions that power insightful reports/ dashboards driving analysis and decision making. This role requires that the person is based in Austin, TX.

Position Responsibilities:

• Design, develop, deploy, and maintain high-quality, scalable solutions across the entire data lifecycle, from raw data to analytics ready data sets enabling visualization team to build powerful insights & analytics.
• Partner with a cross functional team of business users, visualization experts and measurement & evaluation staff to understand, develop & document business requirements, translate to technical requirements and guide envisioning the end solution.
• Building data solutions: Clean and transform raw data from various internal & external data sources into consumable information and business logic, curate user-ready datasets and data sources. Expand our data marts with clean data ready for analysis.
• Help define and improve our internal data infrastructure including development methodology, CI/CD and QA processes.
• Monitor, debug and maintain data transformations.
• Profile data sets for completeness and validity, and build automated SQL scripts to assess completeness, validity, and other data metrics for the data warehouse.

Technical skills and experience:

• Bachelor's degree in computer science, MIS, or a related field or equivalent experience required
• Minimum of 3 years’ experience building data warehousing, business intelligence, and analytics solutions using Microsoft technologies on-perm and in the cloud.
• 4+ years working experience with SQL Server including advanced T-SQL, SQL for data analysis, query tuning and SQL Server agents
• Strong knowledge of Data warehousing, Dimensional modeling and ETL concepts & techniques
• Experience in using Business Intelligence toolsets in the areas of data modeling, data extraction, transformation, and visualization

• Hands-on experience in ETL/ELT configuration, deployment, and troubleshooting
• Experience in creation of CI/CD pipeline, data integrity checks and QA processes.
• Experience building dashboards on Tableau and/or Power BI (Tableau nice to have)
• Background in Scrum/Agile project management environment
• Experience with Microsoft Cloud data storage & analytics solutions/ services like Azure Data Factory, Azure Synapse is a plus

Further, to be successful in this role, the candidate must have:

• Strong analytical and problem-solving skills paired with an ability to context switch easily, manage multiple priorities, and deliver effective solutions
• Ability to build and grow relationships leveraging excellent verbal and written communication skills and demonstrating a strong focus on customer success
• Ability to work both independently and collaboratively with others in team environment
• Ability to work through ambiguity and handle requests from a wide breadth of domains.
• Keen attention to detail, honesty, adaptability, dependability, and a willingness to do hands-on work

The Michael & Susan Dell Foundation has adopted a hybrid working model combining in-office and virtual work.

The foundation is an equal opportunity employer and is committed to creating a diverse workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, national origin, genetics, disability, age, or veteran status.