Role: Sr Data Engineer
Location: Phoenix, AZ (Hybrid)
Experience: 10+ Years
Key Responsibilities: • Solid experience with Database design practices and data warehousing concepts. • Design, develop, and maintain data pipelines and ETL processes to extract, transform, and load data from various sources into our data warehouse. • Hands on experience delivering data reporting requirements on On-Prem SQL Servers using SSIS and/or other integration processes. • Expertise with coding and implementing data pipelines in cloud-based data infrastructure in batch and streaming ETL using Azure Data Factory, Spark, Python, Scala on Databricks. • Experience working with Azure data lake storage and Azure SQL Databases. • Experience working with Databricks Delta Lake and Medallion Architecture and Unity Catalog. • Optimize data ingestion and transformation processes to ensure efficient and scalable data flows, Monitor and optimize database performance, including query tuning and index optimization. • Develop and maintain data models, schemas, and data dictionaries for efficient data storage and retrieval. • Perform data analysis, data profiling, and data cleansing to ensure data quality and accuracy,data validation, quality checks, and troubleshooting to identify and resolve data-related issues. • Develop Power BI dashboards, reports, and visualizations to effectively communicate data insights. Implement data transformations, data modeling, and data integration processes in Power BI. • Create and maintain technical documentation related to database structures, schemas, and Reporting solutions. • Experience with MS office tools like excel, word, power point. • Experience working with build and deploy tools Azure DevOps, GitHub, Jenkins. • Experience working on an Agile Development team and delivering features incrementally using Jira and Confluence. • Stay up to date with industry trends and best practices in data engineering, Power BI and proactively recommend and implement improvements to our data infrastructure. • Ability to multi-task, be adaptable, and nimble within a team environment. • Strong communication, interpersonal, analytical and problem-solving skills.
Preferred: • Experience with API/REST, JSON • Experience in Banking and Financial Domains. • Industry certification - Azure/GCP/AWS • Familiarity with a variety of programming languages, like Java, JavaScript, C/C++. • Familiarity with containerization and orchestration technologies (Docker, Kubernetes) and experience with shell scripting in Bash, Unix or windows shell is preferable. • Experience with Power Automate and Power Apps. • Experience with Collibra Data Lineage and Data Quality Modules.
Education: Bachelors degree in computer science or information system along with work experience in a related field.
#LI-BP1
For over two decades, Sharp Decisions has provided superior, award-winning service in strategic business and technology consulting services to government agencies at all levels, as well as domestic and global corporations. With subject matter expertise in Investment Banking, Finance, Healthcare, Media & Telecommunications, and Manufacturing, Sharp Decisions is well equipped to serve your needs.
Established in 1990 with headquarters in New York City, and locations in Princeton, Charlotte, Los Angeles, Phoenix, Europe and Canada, Sharp Decisions has been the technology backbone for a client portfolio that includes an array of well-known companies. As a Certified Woman-Owned Business Enterprise and approved vendor, Sharp Decisions offers a powerful, cost-effective advantage. We actively partner with other MBEs to add value and meet diversity program requirements.
Sharp Decisions is also committed to hiring and training post-9/11, tech-savvy U.S. armed forces veterans through our V.E.T.S.â„¢ (Vocation, Education and Training for Service members) Program, but we cannot do it alone. Companies like EmblemHealth, Freddie Mac and Experian have stepped up to bring aboard our highly qualified and skilled veterans. We need more companies like them to take a stand and bring our veterans aboard. Our clients have told us that our veterans are more effective than their college hires because two weeks on the job for them equates to 2-3 years of experience! Learn more at www.sharpdecisions.com/vetsprogram.