• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 28th Dec 2023

Must-Have:

•         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 and operational requirements to      

          assist IT staff with implementation of finance and accounting system solutions.

•         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 business insights based on large-scale data.

•         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 for different audiences.

•         Develops visually appealing and intuitive dashboards that provide visibility into key performance, risk, and control indicators

          across agency divisions and departments.