23-00166 ETL Developer with Azure >>> W2 ONLYLocation: 100% REMOTE – Pacific Time hoursThis is a Full Time position!
MUST have current LinkedIn profile that matches resume exactly!
Responsibilities/Essential Functions:· Design, implement, and continuously improve data analytics platform· Implement optimized and simplify data query and analysis capabilities of the data platform· Develop and improve the current architecture, emphasizing data security, data quality and timeliness, scalability, and extensibility· Deploy and apply big data solution and run pilots to design highly performing and low latency data architectures to scale· Collaborate with cross functional team and develop, implement, and validate KPIs, statistical analyses, data profiling, prediction, forecasting, clustering, and machine learning algorithms· Leverage best practices, disciplined approaches, and standards to solving technical problems.· Perform ongoing monitoring, optimization, and refinement of reports and BI solutions· The role entails 100% hands-on development using MS SQL / Python on MS Azure Synapse Platform· Build data solutions with efficiency in handling data - tracking data lineage, ensuring data quality, and improving discoverability of data.· Develop big data analytics solutions sourcing data from distributed systems and applications· Ensuring accurate and efficient governance policy development and adherence· Report on statuses when requested· Submit all time and expense reporting procedures accurately and timely· Maintain good standing and completion on all compliance related matters (i.e., assigned mandatory trainings, actions required from audits, corporate policies, etc.)· Perform all additional duties and responsibilities based on the direction and guidance of supervisor Knowledge/Skills/Abilities:· Expertise in ELT optimization, designing, coding, and tuning big data processes using Microsoft Azure Synapse or similar technologies.· Experience with building data pipelines and analytics solution to stream and process datasets at low latencies.· Knowledge of Data Engineering and Data Operational Excellence using standard methodologies.· Expert level skills writing and optimizing complex SQL · Strong Knowledge of data warehousing frameworks and methodologies.· Proven ability to foresee opportunities to innovate and leads the way· Excellent verbal and written communication· Proven interpersonal skills and ability to convey key insights from complex analyses in summarized business terms· Ability to effectively communicate with technical and non-technical teams· Ability to work with shifting deadlines in a fast-paced environment Skilled and proficient in MS Office O365 suite (i.e. Word, PowerPoint, Excel, SharePoint, Teams, Communications Tools, etc.)· Ability to operate with a customer-centric service approach Experience/Qualifications:· Bachelor's degree in Computer Science, Mathematics, Statistics or related field or 6+ years relevant experience· Experience in data mining, profiling, and analysis· Experience in Azure Data Factory and Azure SQL DW· Experience with complex data modelling, ELT design, and using large databases in a business environment· Five years' experience with languages like SQL, Python, Ruby, Java, or similar language· Must have at least three years of work experience in Big Data projects such as Microsoft Azure Synapse or similar a must