Hello Vendors,
This is Urvish from Cambay Consulting LLC, I tried calling you regarding an amazing opportunity with Georgia Department of Labor (GA DOL) for the position of Report Developer at Atlanta, GA.
Kindly go through the email below and let me know the best time to reach you.
Position Details:
Client: | Georgia Department of Labor |
Job Title: | Report Developer |
Job ID: | 637264 |
Interview Mode | Web Cam or In Person |
Location: | 223 Courtland Street, Atlanta, GA 30303 |
Duration: | 12+ Months |
Job Summary:
We are looking for a Report Developer that has experience with Microsoft’s SQL Server Reporting Services (SSRS) and Power BI Pro. The Report Developer will lead effort utilizing SSRS and Power BI to gather requirements from business users, design reports/dashboards to meet the business user’s requirements, develop the solution, implement the solution and maintain them. The Report Developer will also use other tools, such as Microsoft’s SQL Server database, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SharePoint.
Job Responsibilities
Once the report developer understands the specific data that each department needs they design reports for staff and departments. Their objective is to design a report system that is easily accessible and that users can adjust in order to specify the needed data. This may mean creating an interface allowing the user to set time parameters for the data or to limit data to a specific employer. They configure the reports to connect with databases of information and present the relevant information needed for specific, identified purposes in order to be useful. They also configure systems to collect data from multiple sources, which allows staff the access to all relevant information. Once they have developed a report design they need to test their reports to ensure they work as intended.
• Power BI report design, modeling, and development.
• Independently execute complex data analysis across multiple platforms using Excel, Power BI, Power BI Paginated, or other available tools. Strong data analytics skills to troubleshoot data issues.
• Utilize reporting tools to design and deliver dashboards and reports to stakeholders using an agile-like methodology for increased stakeholder engagement and faster time to market.
• Develop SQL scripts to validate financial and statistical measures presented in Power BI and Power BI Paginated reports.
• Demonstrate a deep understanding of the enterprise reporting development and delivery domain areas, using multiple technologies and tool sets.
• Develop detailed requirements documentation including user stories, use cases, design specifications, business process, data flows and acceptance criteria.
• Accountable for deliverables by understanding and balancing the competing demands for project scope, time and quality.
• Understand and apply the enterprise vision and strategy to the project solution while balancing tactical needs to deliver.
• Ensure that all delivered solutions meet the highest quality standards and satisfy all specified business requirements through rigorous validation and testing.
• Manage support issues raised by the business through to resolution and within defined support SLAs.
• Confidently participate in meetings and manage frequent communications with all levels of the organization including key stakeholders and senior management.
• Be very resourceful to proactively identify and engage available resources and subject matter experts in related areas to achieve your goals, with a strong ability to multitask and manage time and priorities under pressure while meeting deadlines.
Required Skills:
1. Five years’ experience with SQL.
2. Five years’ experience with Microsoft’s SQL Server Database.
3. Three years’ experience with Microsoft’s Excel.
4. Three years’ experience with Microsoft’s SQL Server Reporting Services (SSRS).
5. Three years’ experience with Microsoft’s SSRS Report Server.
6. Two years’ experience with Microsoft’s SQL Server Integration Services (SSIS).
7. Two years’ experience with Microsoft’s Power BI Desktop or Power BI Pro.
8. Two years’ experience with Microsoft’s Power BI Report Server.
9. Two years’ experience with Governance of Report Development: Policies, Standards, Procedures, Guidelines and Security.
10. Two years’ experience with Microsoft’s SharePoint.
Desired Skills:
1. Experience with Unemployment Insurance (UI) Benefits.
2. Experience with SQL Server Database 2016 or higher.
3. Experience with Windows Server version 2016 or higher.
4. Experience with DB2 LUW database version 10.5 or higher.
5. Experience with Microsoft’s SQL Server Management Studio (SSMS).
6. Experience with Extract, Transform and Load (ETL) tools such as Informatica and WhereScape.
7. Experience with IBM’s QMF.
8. Experience with Microsoft’s SQL Server Analysis Services (SSAS)
9. Experience with Tableau.
10. Experience with Teradata database
11. Experience with Information Builder’s WebFOCUS
12. Experience with the Python or R programming languages.
13. Experience with Windows PowerShell scripting language.
14. Experience with Local, State or Federal government.
15. Experience with LRS’ PageCenterX.
Personal Qualities:
Be innovative, energetic, energizing, flexible and eager to learn. Excellent work ethic, attention to detail, ability to work in a highly collaborative, collegial, multidisciplinary fast paced team environment. Excellent analytical skills with the ability to manage multiple priorities and requests. Excellent communication and interpersonal skills. Ability to work independently and meet requested deadlines promptly.
Skill Matrix:
Skill | Required / Desired | Amount | Experience |
Experience with Governance of Report Development: Policies, Procedures, Guidelines, Standards and Security. | Required | 5 | |
Experience with SQL. | Required | 5 | |
Experience with Microsoft’s SQL Server Database. | Required | 5 | |
Experience with Microsoft’s Excel. | Required | 5 | |
Experience with Microsoft’s SQL Server Reporting Services (SSRS). | Required | 3 | |
Experience with Microsoft’s SSRS Report Server. | Required | 3 | |
Experience with Microsoft’s SharePoint. | Required | 3 | |
Experience with Microsoft’s SQL Server Integration Services (SSIS). | Required | 2 | |
Experience with Microsoft’s Power BI Desktop or Power BI Pro. | Required | 2 | |
Experience with Microsoft’s Power BI Report Server. | Required | 2 | |
Experience with Unemployment Insurance (UI) Benefits. | Highly desired | 2 | |
Experience with IBM's DB2 LUW database. | Highly desired | 2 | |
Experience with Extract, Transform and Load (ETL) tools such as Informatica, Pentaho and WhereScape. | Desired | 1 | |
Experience with Information Builder’s WebFOCUS. | Desired | 1 | |
Experience with Tableau. | Desired | 1 | |
Experience with LRS' PageCenterX. | Desired | 1 |
Thanks and Best regards,
Urvish Rai
Ph.: 832-761-3192
Cambay Consulting LLC.
1838 Snake River Road,
Suite A, Katy, TX 77449
::DISCLAIMER::
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or CAMBAY or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of CAMBAY or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of CAMBAY is strictly prohibited. If you have received this email in error, please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.