| Sr. Data Engineer at Dallas, Texas, USA |
| Email: [email protected] |
| From: Sonali, KPG99 [email protected] Reply to: [email protected] Job Title: Sr. Data Engineer Visa: GC, USC only Duration: 6+ months Location: Dallas, TX (Hybrid 3 days onsite in a week) (1st Round will be face to face interview) Position Summary The Senior Data Engineer serves as a developer for data extract, transform and load processes, primarily for use in the data warehouse or for reporting and analytics. This role is focused on transforming source system input data to a star schema / dimensional model output reliably and at scale. There is a large focus on data quality, deduplication, end-to-end data flows and placing business logic in the appropriate layer. The candidate needs to be a team player and work well with others, both in person and in virtual meetings. A strong attention to detail, coupled with a sense of ownership of the deliverables is a must. The ability to deal with ambiguity and changes in direction while working on multiple projects is very important to succeed in this role. Having a consulting mindset of solving problems rather than taking orders is another important aspect. There is a strong focus on financial business processes, understanding how applications work and store data, dataflow documentation, deduplication, aggregation and cleansing of data. Data warehousing experience is a must, with a strong focus on performance tuning, optimization, and deduplication to ensure scalability and correctness of the system. Experience from the financial sector, data warehousing, SQL Server / TSQL, Python Power BI, agile, and cloud computing, particularly MS Azure or GCP, are strongly preferred. Exposure to data modeling, primarily for data warehousing, is a plus. As a person you need to enjoy learning new things and growing your skillset. Essential Duties and Responsibilities Receive and comprehend change specifications from Business Analysts, management, and business stakeholders as appropriate Develop solutions using, primarily in SQL, to achieve success criteria outlined in specifications Estimating work complexity and timeframes based on specifications Actively participate in code reviews, retrospectives, and demos Do initial testing to verify code functionality and correctness according to specifications Understand ETL solutions tradeoffs for indexing, uniqueness, parallelism, and data dependencies Function as tier 2 support for existing production code Maintain and update tasks and user stories to update progress in an agile project Acquires and maintains application expertise through certification and educational programs. Provides user support, including researching issues, determining options for resolution as needed. Complies with bank policies as applicable to this position. Performs other duties and responsibilities as assigned. Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Skills Ability to read and comprehend simple instructions, short correspondence and memos. Ability to write good technical Ability to read and interpret documents such as procedure manuals, general business correspondence and/or journals or government regulations. Ability to write simple-to-business correspondence, routine reports, and procedures. Ability to effectively speak, respond to questions, and present information to the following: one-on-one /small groups, customers, employees, clients, managers, top management, public groups, board of directors, and the general public. Education and/or Experience BS/BA Degree (four year) from an accredited university/college AND Four to ten years of experience as a Data Engineer Computer Skills Experienced with SQL and data warehousing, particularly star schema models Python experience required Google Big Query, Microsoft Azure Synapse, Data Factory, SQL Server, SSIS, SSRS, SSAS, or similar tools Experience with cloud-based data warehouse platforms a plus Git source control and Agile methodology preferred Power BI or similar tools highly preferred R, SAS or other relevant experience in data analytics is a plus C#, Java, or similar programming experience a plus MS Office programs Certificates, Licenses, Registrations Microsoft Azure certifications is a plus GCP certification is a plus Other Qualifications (including physical requirements) Strong oral and written communication skills. Strong organizational, problem solving, and planning skills with the ability to set priorities. Comfortable interacting with co-workers in virtual environments such as MS Teams or Zoom General banking knowledge required Thanks & Regards Sonali Kumari Technical Recruiter KPG99, INC Keywords: csharp business analyst business intelligence rlang green card microsoft Colorado Texas |
| [email protected] View all |
| Thu Aug 17 03:38:00 UTC 2023 |