*job details*
as a sr manager - strategic data engineer, you will need to respond to the shifting business needs and priorities in systematic and effective way, translating enterprise or business requirements into information/data architecture solutions, including conceptual, logical, and physical models. Qualitative expert with exceptional speed in analysis of quarterly and annual reports and providing comprehensive synthesis.
*how will you do it?*
- create etl jobs using talend big data studio, implement java routines and deploy jobs in tac.
- extensively used pig for data cleaning and optimization to analyze large datasets.
- build, maintain hive scripts, partitions and complex queries for data analysis and extraction.
- handle importing of large data sets from various erps into hdfs using sqoop.
- perform data analysis using spark’s scala apis and spark sql.
- create the end user reports using the power bi reporting tool.
- implementing and promoting governance processes for information and metadata to ensure establishment of a common language and the ongoing accuracy, validity, and reuse of metadata
- ability to work in challenging environment and strong interpersonal, organizational, communication and problem-solving skills
- ability to adapt new technologies and ability to work in-groups as well as independently with minimum supervision
- strong understanding of hadoop fundamentals with extensive experience in designing high performance, scalable data solutions using big data processing frameworks and tools
- deep knowledge in sql and relational databases.
- work across multiple cross-functional teams in high visibility roles and own the data solution end-to-end.
- participated in all phases of development life cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
- developed stored procedure and python framework to automate the testing process to ease qa efforts and reduced the test timelines for data comparison on tables.
- involved in production deployment activities, creation of the deployment guide for migration of the code to production, also prepared production run books
- enforced best practices for design, development, release management and production support
- developed ingestion pipelines from on-prem data lakes, sap and other systems to adls raw layers using adf
- designed and developed transformation logic for dimensions, facts and other tables using azure databricks with pyspark and sql
- designed and developed type1, type2 dimensions for different data warehouse solutions using databricks and synapse
- designed and developed power bi reports for capex, supply chain and finance
- designed and developed planning and reporting solutions for revenue, hr and capital planning
- designed and developed hana information models and power bi reports on hana
*what we look for?*
- bachelor degree in it area or relates, from an accredited university
- fluent english
- 10+ years of information systems experience
- 10+ years performing business analysis related work
- 10+ years of it experience supporting finance//commercial//operational functional areas
- expert knowledge and experience in bigdata and cloud technologies
- ability to lead and collaborate with other enterprise architects, data platform architects and security architects to deliver scalable, secure, and resilient iaas and paas platform solutions in azure
- proficiency in extracting data from various structured & semi structured data sources
- expert knowledge in creating reports and dashboards using power bi and oracle business intelligence
- advanced sql experience with the ability to build complex sql queries to prep and blend data.
- proficient in using business intelligence tools such as power bi, power apps and azure.
- exposure to various development methodologies including pm & agile
- knowledge of microsoft office 365 suite for development
- proven ability to critically think and creatively problem solve.
- strong presentation and interpersonal skills.
- experience connecting directly to multiple databases to extract, prep, and blend large datasets
- strategic, intellectually curious thinker with focus on outcomes
- strong communication skills (english and spanish)
- strong interpersonal skills; ability to work effectively across organizational boundaries and geographies and lead by influence.
- ability to work in a matrix environment with multiple it and user groups
- problem-solving skills - ability to navigate technology and organizational issues to complete project tasks
- proven implementation and problem-solving experience - including troubleshooting, performance tuning and resolving connectivity issue
- must have experience working on projects as well as handling day-to-day operational requests from the business
*experience with following tools*:
- strong knowledge skills of ms sql
- power apps
- microsoft flows
- sharepoint
- knowledge of r, python,