Required Skills

ETL

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 29th Dec 2023

JOB DETAIL

  5+ years of expert TSQL/Procedural language and SSIS experience

                                                                                                •         Strong SQL experience, specifically SQL Server 2012.

                                                                                                •         Knowledge of data governance standards.

                                                                                                •         Advance TSQL coding a must

                                                                                                •         Hands on Dimensional Modeling

                                                                                                •         Hands on data transformation with SSIS and SQL Agent for automation and scheduling

                                                                                                •         Good understanding of Data warehouse concepts.

                                                                                                •         Azure working knowledge, don't need to be expert

                                                                                                •         Tableau knowledge is good to have

                                                                                                 

                                                                                                Job Responsibilities

                                                                                                •         Defines, develops, and implements automation of reports, processes, and interfaces.

                                                                                                •         Designs and develops models to improve financial analysis and to project financial impact of business changes.

                                                                                                •         Interprets and translates accounting and finance business needs into effective applications

                                                                                                •         Works with IT and Finance to perform testing and facilitate implementation of data warehouses.

                                                                                                •         Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.

                                                                                                •         Understands and compiles accurate data to present reports and assesses data quality.

                                                                                                •         Applies a broad range of techniques and theories from business intelligence, data analysis and visualization, statistics, and predictive analytics to deliver actionable

                                                                                                •         Defines, captures, enriches, explores and preps data to support desired metrics monitoring and reports.

                                                                                                •         Troubleshoots and resolves problems related to accounting and finance systems and applications.

                                                                                                 

                                                                                                Skills:

                                                                                                •         Extensive knowledge of SQL

                                                                                                •         SQL Server Management Studio experience

                                                                                                •         Extensive knowledge of complex data models

                                                                                                •         Strong data analysis/mining experience

                                                                                                •         Strong data validation skills

                                                                                                •         Strong Experience with ETL tools

                                                                                                •         Driving curiosity and attention to detail

                                                                                                Reporting

                                                                                                •         Provides thorough, visible, rigorous and transparent data reports and analysis.

                                                                                                •         Tracks trends and provides recommendations for solutions based on findings.

                                                                                                •         Interprets and communicates analytical insights to audiences with various analytical backgrounds using different but suitable communication methods

Company Information