Job Description
This contract position in the DCF Business Intelligence Section will provide advanced Business Objects expertise for our divisional customers and supporting BI section initiatives. An advanced skill set in Business Objects universe design and report development is required. This individual will follow standards to design, develop, test and implement reports and documentation. The individual will also be expected to assist in training and mentoring other data warehouse developers. The selected contractor is required to show proof of experience in designing and implementing Business Objects universes and reports.
The individual in this position will:
• Be responsible for development and support of enterprise level data assets using Business Objects.
• Work with enterprise wide business and IT senior management to understand reporting and data analysis needs.
• Work with customers gathering requirements for reports and dashboards.
• Have extensive experience working with Business Objects WeBI creating Complex reports.
• Be principally responsible for designing Business Objects universe layer for business intelligence solutions. Optimize the performance of Business Objects constructs. As necessary, communicate with data modelers/DBAs to optimize database for reporting performance.
• Have mastery level understanding of Business Objects security administration. Serve as coordinator with DCF security for creation of new groups and complex user security issues.
• Have expert level knowledge of Business Objects universe configuration (parameter settings, etc.) and universe design aspects (resolving loops, contexts, aliases, cardinality, etc.) Expertise with SAP Information Design Tool.
• Work interactively with both technical and non-technical staff to build Business Objects universe layer that adheres to underlying data model and effectively delivers data to end users.
• Have extensive experience in working within a Business Intelligence environment and knowledge of data warehouse modeling and design
• Stay up-to-date on releases / patches for Business Objects. Act as a Business Objects subject matter expert for fellow technologists as well as end users.
• Understand logical and physical data modeling and methods for optimizing the Business Objects universe against the physical model. Have expertise in SQL
• 4 to 6 years of experience with enterprise level database systems, business intelligence tools and reporting systems.
Comments:
1. Phone & Web Based interviews acceptable for interviews prior to final interview. An in-person interview will be required before a final hire is made.
2. Please bring three (3) business references to an interview.
3. The selected candidate will be required to complete a criminal background check.
4. This position is budgeted for 1960 hours annually. Hours will be prorated the first year based on start date.
5. DCF does not sponsor work visas, either at the time of hire or at any later date
6. In coordination with the “Safer At Home†guidelines, contracted staff will work with their manger to access work remotely as needed temporarily. However, contract staff will be required to return to the home office for regular business hours as restrictions allow.
Phone, Web Based, and/or In-Person interviews acceptable for all interview phases
Powered by JazzHR
Fideaux is seeking an Senior SQL Server Data Warehouse and SSRS Developer for a immediate contract opportunity. This work is 100% Remote on a 1099 arrangement only. You can be located anywhere in the USA. You need to provide your own computer, phone and internet access.
Role: Senior SQL Server Data Warehouse and SSRS Developer
The Senior Developer (Contractor) will be responsible for the development and loading of the Call Centric Data Mart from vendor's Call Center and IVR applications. Along with building SSRS reports for the dissemination of analytical data to management and key stakeholders.
The Contractor is also responsible for helping establish an enterprise reporting framework that aligns with other areas of the overall enterprise architecture.
Tasks/Deliverables
1. Development of the ETL process to load 70+ text files from the Call Center and IVR applications into Staging, Dimension, Fact tables.
2. Design and develop reports as required by various projects using SQL Server Stored Procedures and SSRS tools.
3. Provide production support by responding to issues, alerts, business and IT inquiries that are related to reports
4. Work with staff and vendors to troubleshoot issues, implement patches, and/or upgrades as required to ensure the optimal performance and function of the reporting tool/platform.
5. Provide Production Support assistance for the existing ETL job streams.
Minimum Technical Qualifications
1. At least (15) years of experience designing, developing, debugging and supporting complex data integration interfaces and processes (including stored procedures, triggers, tables, user defined functions, views, indexes, relational database models) using various tools and technologies including SSIS, SSAS, SSRS, T-SQL and SQL Server technology. This experience must include full time experience in developing ETL scripts and writing PL/SQL code from data model, dataflow diagram and technical design specifications.
2. At least (10) years of experience working as a ETL developer creating and fine-tuning SQL reports from data stored in SQL Server databases. This experience must include experience designing robust Logical Data Models and stewarding the data design of the solution and ensuring alignment with the larger roadmap goals.
3. At least (15) years of experience developing complex SQL queries; developing detailed SQL reporting specifications; aggregating, analyzing, validating, and/or reconciling data from heterogeneous data sources, e.g. MS SQL Server, XML files, CSV files, text files, etc.).
4. At least (15) years of experience demonstrating understanding of SDLC methodologies specific to requirements elicitation and analysis, analyzing business processes, business process modeling, preparing business use cases, logical data modeling, and user interface design for reports.
5. At least (10) years of experience working with Microsoft products/tools such as Power BI, SQL Server versions 2012/14, SQL Server Reporting Services, etc.
6. At least (10) years of experience monitoring the performance of reports and taking corrective action to optimize or improve the performance of the reports when necessary.
7. At least (10) years of experience designing and implementing Ad-hoc, Canned and Operational business intelligence (BI) reports using various BI reporting tools such as Microsoft Power BI and associated tools and technologies.
8. At least (10) years of experience producing and assisting in the creation of the following documents: Reports Specification document, data dictionary, reporting tool/platform architecture, test scenarios and test cases for reports testing, etc.
Desirable Technical Qualifications
1. Expertise in the field of Data Integration, Data Conversion, and ETL.
2. Expertise developing SQL Reports as part of the data integration solutions.
5. Experience following specifications provided by a Data Architect for development of SQL Server Integration Services based solutions for migrating data in both OLTP and Data Warehouse environments.
7. Working knowledge of industry standard data replication and data integration tools.
8. Strong understanding of SQL Server Reporting Services Security Model and integration with Microsoft Active Directory and SharePoint Technologies.
9. Extensive knowledge and understanding of SQL Server/MS.Net technologies and/or products.
11.Proven ability to work both in a team environment and independently.
12.Excellent oral communication skill and technical writing skill.
13.Ability to organize material, analyze a wide variety of facts and develop appropriate recommendations.
About Fideaux:
Fideaux, Inc., (Headquartered in Powhatan, VA) is an IT & Financial Solutions provider committed to delivering results. Since our founding in 2012, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value.
Please respond with a copy of your resume MS Word resume.
Selected candidate will have to complete background check.
Relocation and living expenses not funded
Job Type: Contract
Pay: $60.00 - $80.00 per hour
Schedule:
Experience:
Contract Renewal:
Full Time Opportunity:
Work Location:
Visa Sponsorship Potentially Available:
This Job Is:
Work Remotely:
Data Architect (BI)
Greater Manchester (Remote Working)
Upto £500 per day
Would you like to lead and oversee a full SQL Server Data Warehouse lifecycle from Development through to Implementation?
Would you like to enhance both your Project Management and Stakeholder Management skills?
I currently have a contract Data Architect (BI) opportunity based with a client based within the Greater Manchester area. The contract will last circa 6 months, with the vast majority of this being remote.
As a Data Architect, you will play a leading role in laying the foundation for data & reporting for this client for the next several years.
Sr SQL Server Developer
Full Remote
Responsibilities:
Job Type: Contract
Pay: $1.00 - $2.00 per hour
Schedule:
COVID-19 considerations:
Fully Remote
Company's website:
Sr SQL Server Developer
Full Remote
Responsibilities:
Job Type: Contract
Pay: $1.00 - $2.00 per hour
Schedule:
COVID-19 considerations:
Fully Remote
Company's website:
Sr SQL Server Developer
Full Remote
Responsibilities:
Job Type: Contract
Pay: $1.00 - $2.00 per hour
Schedule:
COVID-19 considerations:
Fully Remote
Company's website:
Sr SQL Server Developer
Full Remote
Responsibilities:
Job Type: Contract
Pay: $1.00 - $2.00 per hour
Schedule:
COVID-19 considerations:
Fully Remote
Company's website:
You may send your resume to applicant@gdii.com
About GDI Infotech:
GDI Infotech is an award-winning Information Technology company based in Ann Arbor, Michigan. With our firsthand IT knowledge and 25+ years of experience, we carefully evaluate the technical expertise of our candidates, making us talent acquisition experts in both IT technologies and project management. We have proved our excellence with a wide variety of clients including the State of Michigan, Quicken Loans, Dart Container, and more.
Convert existing Esri Silverlight API applications into standard Esri ArcGIS Enterprise 10x (Javascript API/WebApp Builder) applications within SharePoint web sites/integrated applications/mobile solutions for the Georgia Dept. of Transportation.
Location:
600 West Peachtree Street NW, Atlanta, GA 30308
Responsibilities:
Candidate will be working in the Enterprise GIS Team of IT Applications. Candidates will work with supporting IT team members (database, network, server, etc.) and interacting with business units. The candidate will follow internal SLDC, standards, and accepted best practices for developed solutions.
The Enterprise GIS team is composed of 2 ArcGIS developers, 2 System Administrators, a data manager, and team leader. The team supports over 180 ArcGIS Desktop users and approximately 60,000 annual ArcGIS Server web visits. Applications support GIS portal, feature mapping, project planning, emergency operations, permitting, safety, and traffic records.
The team develops enterprise GIS services, applications, and databases. The team coordinates with client, server, network, and database/data warehouse personnel to support and develop the underlying IT solutions.
The position end date is set for the end of the Georgia DOT fiscal year. Georgia DOT may exercise the option to renew contracts in one year increments. Several successful consultants have continued working for several years with contract extensions. However, Georgia DOT is under no obligation to extend contracts and may terminate employment at any time.
GDOT will not increase the pay rate within 2 years of active engagement. After 2 years of engagement, GDOT at its sole discretion may assess pay rate increases. Pay rate increases will be dependent on engagement performance and GDOT budget constraints. GDOT expects pay rate increases to be allocated directly to the person and not suppliers.
All candidates submitted for this or any other Job Posting that are currently working under a VISA, Employment Authorization Card, or any other authorized programs of the Federal Government must have a current active VISA or status in order to be submitted. Candidates that have an expired VISA or are in the process of applying for an extension, transfer, or a new VISA, should not be submitted.
The Department has 12 holidays, which consultants are not allowed to work nor make up any time for those holiday weeks without management's approval.
GDOT will not be providing any raises within the first 2 years. After that point the rate increase will be based on performance and budget dependent.
Position will be working remotely during COVID-19 and transition to on-site at 600 West Peachtree Street NW, Atlanta GA 30308 as per GDOT workforce re-entry plans.
Candidate will be working in the Enterprise GIS Team of IT Applications. Candidates will work with supporting IT team members (database, network, server, etc.) and interacting with business units. The candidate will follow internal SLDC, standards, and accepted best practices for developed solutions.
The Enterprise GIS team is composed of 2 ArcGIS developers, 2 System Administrators, a data manager, and team leader. The team supports over 180 ArcGIS Desktop users and approximately 60,000 annual ArcGIS Server web visits. Applications support GIS portal, feature mapping, project planning, emergency operations, permitting, safety, and traffic records.
The team develops enterprise GIS services, applications, and databases. The team coordinates with client, server, network, and database/data warehouse personnel to support and develop the underlying IT solutions.
The position end date is set for the end of the Georgia DOT fiscal year. Georgia DOT may exercise the option to renew contracts in one year increments. Several successful consultants have continued working for several years with contract extensions. However, Georgia DOT is under no obligation to extend contracts and may terminate employment at any time.
GDOT will not increase the pay rate within 2 years of active engagement. After 2 years of engagement, GDOT at its sole discretion may assess pay rate increases. Pay rate increases will be dependent on engagement performance and GDOT budget constraints. GDOT expects pay rate increases to be allocated directly to the person and not suppliers.
All candidates submitted for this or any other Job Posting that are currently working under a VISA, Employment Authorization Card, or any other authorized programs of the Federal Government must have a current active VISA or status in order to be submitted. Candidates that have an expired VISA or are in the process of applying for an extension, transfer, or a new VISA, should not be submitted.
The Department has 12 holidays, which consultants are not allowed to work nor make up any time for those holiday weeks without management's approval.
GDOT will not be providing any raises within the first 2 years. After that point the rate increase will be based on performance and budget dependent.
Position will be working remotely during COVID-19 and transition to on-site at 600 West Peachtree Street NW, Atlanta GA 30308 as per GDOT workforce re-entry plans.
We are looking for a specialized Game developer to turn a game idea into code on a fast moving environment. You will be involved in various aspects of game’s creation from concept to finished product including coding, programming, audio, design, production and visual arts.
Responsibilities
Skills
Job Types: Full-time, Contract
Pay: $90,000.00 - $100,000.00 per year
Schedule:
Experience:
Education:
Work authorization:
Work Location:
Position –SQL Database Administrator(Only local to North Carolina)
Location: Raleigh,NC
Duration : 6+ months (Possibility To extend)
Rate- $60-$75/hr
****Candidates will be allowed to work remotely. However, he/she does need to be onsite as required, likely once a week. The candidates will need to be in Raleigh so he/she can come onsite at short notice. Candidates need to be local to Raleigh, NC.
The individual will be accountable for successful design, development and delivery of SQL solutions within on prem and cloud environments. An ideal candidate will be someone who leads, develops, maintains, and integrates processes for a data warehouse that will extract data from standardized or varied data sources and transforms data for storing in proper formats and structures for querying and analysis using SSIS. This would include loading data into an operational data store (ODS), and a dimensional model (EDM). Responsible for architecting, testing, implementation of solution as well as mentoring and training other SSIS/ETL developers in technology and business processes.
Expected Skills: Able to work without assistance; can provide leadership to others; able to manage highly complex work efforts; may have advanced education; may have extensive industry experience.
Responsibilities (including, but not limited to):
1. Data analysis and database management
2. Strong experience using SSIS as the ETL tool in a data warehouse environment.
3. Exercises, in conjunction with the enterprise data architect, independent decision making to creates processes which initiate the ETL, developing stream-lined processes for extracted data loading to destination databases.
4. Performs data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, gathering of natural keys, and metadata information.
5. Creates data validation rules on source data to confirm the data has correct and/or expected values.
6. Creates process cleanup after complex ETL processes which release resources used to run ETL. This would include error handling and SSIS restart.
7. Designs and implements technology best practices, guidelines, and repeatable processes.
8. (Physical) Environment-level administration; installation/patch/upgrade of database software; management of HA, database-level security; maintenance of database configuration files and data files; completion of database reorganizations, environment tuning, refreshes, exports and imports, backup and recovery; performance of capacity planning driven by technology and resource usage trends
This work order is essential for service delivery of the following: A new System Office Analytical Data Warehouse in the cloud.
The DBA Team has one (1) SQL Server Administrator on staff. These positions will work with the DBA team in conjunction with the Data Warehouse team.
Job Type: Contract
Pay: $60.00 - $75.00 per hour
Schedule:
Education:
Work authorization:
Work Remotely:
Job Title: Data Architect
Job Location: Greenfield IN / Remote
Start Date: 9/21/2020
Duration: 6-12 Months Contract
Job Type: Contract
Duration & Type: 3 months contract to start and potential to extend for a year.
Location: Can work remotely with twice a month onsite (Minneapolis, MN)
Required:
For consideration, please send resume to career@infoquestgroup.com
Data Engineer - Freelance
1000 NOK per hour
6-months
Oslo, Norway
As a Data Engineer, you will be building ETL pipelines to connect data from several sources into a new Snowflake data warehouse.
THE COMPANY:
This company are one of the leading Telecom providers across the Nordics. They are on a mission to understand their customers in more detail so they can tailor offers to them. They currently have an Analytics function that are struggling to effectively work with the data. A lot of the datasets are legacy based and it is difficult to streamline records. They are hoping to move to a new 360 solution allowing them to work more efficiently and therefore produce better results.
THE ROLE:
As a Data Engineer, you will be assisting with the migration to a new Snowflake data warehouse hosted within AWS. You are expected to work with Data Scientist, querying datasets using SQL and building ETL pipelines in Python. You will be connecting several sources of data into a single platform that will be used as the central source for all data across their analytics departments. They are using Dataiku for the productionisation of Machine Learning models. While this is not an essential tool, it will help if you have supported Data Science teams. You will also be designing data models using standard techniques like Kimball, STAR etc.
YOUR SKILLS AND EXPERIENCE:
HOW TO APPLY:
Please submit your CV to Henry Rodrigues at Harnham via the Apply Now button.
Please note that our client is currently running a fully remote interview process, and able to on-board and hire remotely as well.