Blog

Please check below  Requirement : 

Note: OPT’s, CPT & H1B and Transfer cases consultants are not workable for this role

SQL Server Developer
SSIS/SSRS

Location:  Wilmington, Delaware 19808
• 2 days onsite
• Will consider remote for high level resources (east coast hours a must)
Duration: 18 months+ project

TECHNICAL SKILLS:
– At the very least, we would want one strong SQL developer that can transform data for reporting, prepare data for ingestion into an SOR system and perform data quality checks; and
– Senior Tableau developer, with SQL understanding.
o For the Tableau developer, we would ideally like someone that can help present data visualization options, and generally uplift our teams UX capabilities.

1. SQL (snowflake ideal – but other databases are fine)
2. Tableau
3. Power BI

Call Notes:
• Data analytics/migration specialist to help with migrations for various systems internally
• Currently moving from in-house proprietary system to salesforce
• Data assessments, profiling data and accuracy
• Testing and validation of data
• Documentation experience key
• Data mapping, testing and prepping for migrations
• For reporting role- someone who can hit the ground running
o Utilizing tableau charts for pulling data insights and reporting
o Data analytics and query experience needed
o SQL experience and working within Snowflake
o Dashboards are built through tableau and business objects

MORE FORMAL Job descriptions:
Sr Data Analyst/Data Migration: – SQL Dev
• Construct, design, write and document complex programs using Business Intelligence Tools (e.g. Business Objects, SAS, SQL, Crystal Reports) to gather statistical data, ensuring that the most efficient procedures are used to access, investigate, and analyze data.
• Develop, analyze, report and interpret complex data for ongoing activities/projects. Ensure that all data is accurate and available to meet establish deadlines.
• Migrate data from various sources to new systems or platforms.
• Work closely with cross-functional teams to ensure the successful transfer of data while maintaining data integrity and security.
• Analyze existing data sources and develop migration strategies.
• Design and implement data migration processes, including data extraction, transformation, and loading (ETL).
• Develop scripts and programs using SQL to automate data migration tasks.
• Working knowledge of databases (Microsoft SQL, Oracle, DB2), programming (XML, JavaScript, or ETL frameworks).
• Collaborate with stakeholders to define data mapping rules and ensure accurate data transfer.
• Perform data quality checks and resolve any issues or discrepancies.
• Monitor data migration progress and provide regular updates to project teams.
• Ensure compliance with data protection regulations and security protocols.
• Technical experience regarding data models (logical and physical) database design development, data mining and segmentation techniques.
• Perform mass data imports/exports using the API or various import tools.
• Familiar with effective approaches and practical experience in data migration, data quality, master data management, and data security, including the use of relevant tools.
• Document migration processes, procedures, and outcomes
Sr Data Analyst/Reporting:
• Collaborate with stakeholders to understand business requirements for reporting needs
• Design and format reports to meet business needs and standards
• Validate report data to ensure accuracy and consistency
• Ensure compliance with regulatory requirements and company policies
• Maintain documentation and ensure all reporting processes are organized and well-documented
• Create and maintain documentation of configurations, processes and procedures within the reporting function
• Establish automation and efficiencies around data and reporting functions
• Leverage expert Business Intelligence (BI) platform skills on one or more platforms to incorporate advanced calculations, develop more advanced data flows and assemble complex consolidated dashboards/reports for presentations.
• Apply standards, templates and themes to create uniform sets of visuals for a given audience. Use knowledge of the principles of visual perception to provide refinement to dashboards/reports, providing rich information in a dynamic and understandable way.
• Create templates for data dashboards/reports for use by data visualization team to support consistency and clarity across data visualizations.
• Implement identified best practices in navigating and publishing BI reports, providing access, managing permissions, and monitoring visualization usage by data users.
• Use knowledge of programming languages to work with data teams to query, structure and model data, as needed, for use in dashboards/reports.
• Use expert knowledge of business and technical metadata, data quality, and issue remediation to create accurate data models within BI tool(s).
• Drive business insights through the development of descriptive, diagnostic, and predictive reporting by selecting appropriate advanced visuals that identify trends and outliers.
• Mentor less experienced team members in the use of dashboard/report templates, data visualization best practices and facilitate learning opportunities.
• Work with business partners to conduct dashboard/report testing and recommend refinements.